package com.goods.business.mapper;

import com.goods.common.model.business.Supplier;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.BaseMapper;

import java.util.List;

public interface SupplierMapper extends BaseMapper<Supplier> {
    //根据查询条件查询列表
    List<Supplier> selectByNameAddressContact(@Param("name") String name,
                                              @Param("address") String address,
                                              @Param("contact") String contact);

    @Select("select * from biz_supplier where name = #{name} or address = #{address}")
    Supplier selectByNameOrAddress(@Param("name")String name, @Param("address")String address);
}
